Course objectives:
|
The aim of the course is to acquaint students with the possibilities how to provide database integrity with procedural means. Next, show other SQL options for creating database applications.
|
Requirements on student
|
Submission and demonstration of a database application meeting the conditions of the assignment. The work includes the proposed data model and application logic implemented by procedural means of the database system. Obtaining a credit until the end of May. Receiving at least 51% of points from of the examination test.
|
Content
|
1. Hierarchical query in Oracle
2. SQL query optimization
3. Embedded SQL - introduction
4. Embedded SQL - cursors
5. PL/SQL - block, stored procedures, functions and packages
6. PL/SQL - cursors, triggers
7. Object extensions of SQL - objects
8. Object extensions of SQL - arrays, nested tables
9. Design of object-relational schemas
10. Design of server-side database applications
11. Restiction of access rights to application components
12. Transaction control, database locks
13. Reserve, discussion
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
-
Basic:
Oracle Database Documentation
(Kolektiv autorů)
-
Recommended:
Connolly, Thomas M.; Begg, Carolyn E. Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson, 2015. ISBN 978-0-13-294326-0.
-
Recommended:
Lacko, Ľuboslav. Oracle : správa, programování a použití databázového systému. 2., dopl. vyd. Brno : Computer Press, 2007. ISBN 978-80-251-1490-2.
-
Recommended:
Heller, J. Pro Oracle SQL Development : Best Practices for Writing Advanced Queries. Apress, 2019. ISBN 978-1-4842-4516-3.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
39
|
Undergraduate study programme term essay (20-40)
|
35
|
Preparation for an examination (30-60)
|
30
|
Total
|
104
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
know the basics of procedural programming |
know the basic graphical notation for the design of the entity-relationship model |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
to design an entity-relationship or relational model of a simple real situation |
implement a relational model of a simple real situation in a selected DBMS meeting third normal form |
write simple statements in SQL |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
N/A |
N/A |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
know the basic language constructions of PL/SQL |
describe and explain the program constructions for the implementation of an active database |
know the basic principles of data indexing |
Skills - skills resulting from the course: |
create and debug stored procedures, functions, and packages in the database system |
use advanced SQL capabilities when building a database application |
Competences - competences resulting from the course: |
N/A |
N/A |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Oral exam |
Continuous assessment |
Seminar work |
Individual presentation at a seminar |
Skills - skills achieved by taking this course are verified by the following means: |
Skills demonstration during practicum |
Continuous assessment |
Seminar work |
Individual presentation at a seminar |
Competences - competence achieved by taking this course are verified by the following means: |
Oral exam |
Skills demonstration during practicum |
Continuous assessment |
Individual presentation at a seminar |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Lecture supplemented with a discussion |
Self-study of literature |
One-to-One tutorial |
Discussion |
Skills - the following training methods are used to achieve the required skills: |
Lecture with visual aids |
Practicum |
Task-based study method |
Skills demonstration |
One-to-One tutorial |
Discussion |
Competences - the following training methods are used to achieve the required competences: |
Interactive lecture |
|